Problem Note 43554: PROC OLAPOPERATE and other administrative calls to the SAS® OLAP Server could cause the OLAP Server to fail
When you navigate within a SAS OLAP cube, MDX queries are generated by the client and sent to the SAS OLAP Server to retrieve the result set for the query. This action causes the query to be added to the session object for the OLAP Server so that administrative calls, like ones made by PROC OLAPOPERATE to list sessions or disable a cube, can locate the active queries.
If an active MDX query is executed but has not fully initialized when an administrative query occurs, this can cause the thread for the administrative query to fail along with subsequent administrative calls. In addition, the OLAP Server might stop responding.
These conditions might result in a traceback such as the following:
0613FD72 068DEDE8 tkmdx:\tkmdx1.c\mdxCompDisableCubes_impl 6001 +(0x12)
060F574B 068DF198 0001:0001474B tkmdx.dll
0610E649 068DF1D0 0001:0002D649 tkmdx.dll
05493DEB 068DF618 tkiompeb:\pebclient.c\pebAddClientLocale 7415 +(0x9CB)
0548C845 068DFB88 tkiompeb:\pebclient.c\clientDispatch 2355 +(0x14F9)
04F98C05 068DFEE0 tkiomsvc:\tkiompdl.c\svcPuddleMain 209 +(0x14D)
050A2339 068DFF40 tkepdl:\tkepdlb.c\puddleInitBasic 668 +(0x1B)
10002289 068DFF70 tkmk:\sktMain.c\sktMain 104 +(0x14)
10003221 068DFF88 tkmk:\TKWINbktMain.c\bktMain 50 +(0xB)
75FDE4A5 068DFF94 kernel32:BaseThreadInitThunk+0xE
7782D4BD 068DFFD4 ntdll:RtlCreateUserProcess+0x8C
7782D6CF 068DFFEC ntdll:RtlCreateProcessParameters+0x4E
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS OLAP Server | z/OS | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2003 for x64 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2008 for x64 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows XP Professional | 9.2 TS2M0 | 9.3 TS1M0 |
Windows Vista | 9.2 TS2M0 | 9.3 TS1M0 |
Windows Vista for x64 | 9.2 TS2M0 | 9.3 TS1M0 |
64-bit Enabled AIX | 9.2 TS2M0 | 9.3 TS1M0 |
64-bit Enabled HP-UX | 9.2 TS2M0 | 9.3 TS1M0 |
64-bit Enabled Solaris | 9.2 TS2M0 | 9.3 TS1M0 |
HP-UX IPF | 9.2 TS2M0 | 9.3 TS1M0 |
Linux | 9.2 TS2M0 | 9.3 TS1M0 |
Linux for x64 | 9.2 TS2M0 | 9.3 TS1M0 |
OpenVMS on HP Integrity | 9.2 TS2M0 | 9.3 TS1M0 |
Solaris for x64 | 9.2 TS2M0 | 9.3 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Topic: | Query and Reporting ==> OLAP (Online Analytical Processing)
|
Date Modified: | 2011-06-30 10:55:31 |
Date Created: | 2011-06-20 10:01:04 |